Tabela CO_STOCKORDERITEM

Definicja tabeli CO_STOCKORDERITEM

Name

CO_STOCKORDERITEM

Code

CO_STOCKORDERITEM

Comment

Tabela pozycji zam??wienia magazynowego


Lista kolumn tabeli CO_STOCKORDERITEM

Name

Code

STOCKORDERITEMID

STOCKORDERITEMID

STOCKORDERID

STOCKORDERID

PRODUCTID

PRODUCTID

QUANTITY

QUANTITY

DICTUNITID

DICTUNITID

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT


Kolumna STOCKORDERITEMID tabeli CO_STOCKORDERITEM

Definicja kolumny STOCKORDERITEMID tabeli CO_STOCKORDERITEM

Name

STOCKORDERITEMID

Code

STOCKORDERITEMID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

klucz g????wny


Kolumna STOCKORDERID tabeli CO_STOCKORDERITEM

Definicja kolumny STOCKORDERID tabeli CO_STOCKORDERITEM

Name

STOCKORDERID

Code

STOCKORDERID

Data Type

NUMBER(10)

Mandatory

No

Comment

klucz obcy do CO_STOCKORDER


Kolumna PRODUCTID tabeli CO_STOCKORDERITEM

Definicja kolumny PRODUCTID tabeli CO_STOCKORDERITEM

Name

PRODUCTID

Code

PRODUCTID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

klucz obcy do CO_PRODUCT, zamawiany produkt


Kolumna QUANTITY tabeli CO_STOCKORDERITEM

Definicja kolumny QUANTITY tabeli CO_STOCKORDERITEM

Name

QUANTITY

Code

QUANTITY

Data Type

NUMBER(20,8)

Mandatory

Yes

Comment

ilo??Ä? zamawiana


Kolumna DICTUNITID tabeli CO_STOCKORDERITEM

Definicja kolumny DICTUNITID tabeli CO_STOCKORDERITEM

Name

DICTUNITID

Code

DICTUNITID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna INSERTDATE tabeli CO_STOCKORDERITEM

Definicja kolumny INSERTDATE tabeli CO_STOCKORDERITEM

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_STOCKORDERITEM

Definicja kolumny INSERTINGPERSON tabeli CO_STOCKORDERITEM

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_STOCKORDERITEM

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_STOCKORDERITEM

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_STOCKORDERITEM

Definicja kolumny LASTMODIFIEDDT tabeli CO_STOCKORDERITEM

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli CO_STOCKORDERITEM

Name

Code

Primary

PK_CO_STOCKORDERITEM

PK_CO_STOCKORDERITEM

X


Klucz PK_CO_STOCKORDERITEM tabeli CO_STOCKORDERITEM

Definicja klucza PK_CO_STOCKORDERITEM tabeli CO_STOCKORDERITEM

Name

PK_CO_STOCKORDERITEM

Code

PK_CO_STOCKORDERITEM

Primary

Yes

Comment